Select cell ranges
Select a custom range of adjacent cells
To select a custom range of adjacent cells, use one of the following methods:
•Move the cursor to the first cell in the desired range. Hold down the left mouse button and drag the cursor to the last cell of the range. Release the left mouse button.
•Select the first cell of the desired range. Hold Shift pressed and select the last cell of the range.
You can select a range in any direction of rows or columns.
Examples of selecting a custom range of adjacent cells:
|
To select non-adjacent cells and ranges, multiple selection is used. |
Select all cells in a spreadsheet
To select all cells in the current sheet within the workspace, do one of the following:
•Move the cursor to the upper left corner of the workspace so that the cursor looks like 
and left-click.
•On the Home tab, in the Edit group, click 
Select all.
•When working in macOS, run the Edit > Select all command from the command menu.
•Press Ctrl+A (Windows, Linux) or 
Cmd+A (macOS).
|
If an element (image, shape or chart) is selected on the sheet, deselect the element before selecting all cells using the Command menu or keyboard shortcut. |
When using these commands, only the cells on the active sheet are selected. Cells on the other sheets in the spreadsheet are not selected.
When switching to another sheet, the range remains selected.
Deselect a cell range
To deselect a cell range, left-click any cell in a spreadsheet.
